import java.sql.*;
public class BianCheng1 {
    public static void main(String args[]) {
        Connection con;
        Statement sql;
        ResultSet rs;
        con = GetDBConnection.connectDB("students","root",""); 
        if(con == null ) return;
        String sqlStr =
                "select * from mess "+"order by birthday";
        
        try {
            sql=con.createStatement();
            rs = sql.executeQuery(sqlStr);
            while(rs.next()) {
                String number=rs.getString(1);
                String name=rs.getString(2);
                Date date=rs.getDate(3);
                float height=rs.getFloat(4);
                System.out.printf("%s\t",number);
                System.out.printf("%s\t",name);
                System.out.printf("%s\t",date);
                System.out.printf("%.2f\n",height);
            }
            con.close();
        }
        catch(SQLException e) {
            System.out.println(e);
        }
    }
}
 class GetDBConnection {
   public static Connection connectDB(String DBName,String id,String p) {
      Connection con = null;
      String 
      uri = "jdbc:mysql://localhost:3306/"+DBName+"?useSSL=true&characterEncoding=utf-8";
      try{  Class.forName("com.mysql.jdbc.Driver"); 
      }
      catch(Exception e){}
      try{  
         con = DriverManager.getConnection(uri,id,p);  
      }
      catch(SQLException e){}
      return con;
   }
}
